﻿CREATE PROCEDURE GetLocation 
@State nvarchar(250) = 'Seberang Perai'   
AS
BEGIN

	SET NOCOUNT ON;

	select l.Location,s.State from AW_Location l
left join AW_State s
on l.StateId = s.StateId 
where s.StatusDelete <> 1 and l.StatusDelete <> 1 and s.State = @State
order by s.State

END
